package com.sto.stoapp.db.constant;

/**
 * 服务短信
 * 
 * @author Administrator
 * 
 */
public interface StoServerSmsConstant extends StoBaseConstant {
	/**
	 * 地址
	 */
	public static final String SERVER_SMS_ADDRESS = "server_sms_address";

	/**
	 * 网点编号
	 */
	public static final String SERVER_SMS_CODE = "server_sms_code";
	/**
	 * 电话
	 */
	public static final String SERVER_SMS_PHONE = "server_sms_phone";

	/**
	 * 服务站点
	 */
	public static final String SERVER_SMS_SERVERSITE = "server_sms_serversite";

	/**
	 * 站点名称
	 */
	public static final String SERVER_SMS_SITE = "server_sms_site";

	/**
	 * 站点编号
	 */
	public static final String SERVER_SMS_SITECODE = "server_sms_sitecode";

	/**
	 * 服务短信下载表
	 */
	public static final String SERVER_SMS_DOWNLOAD_TABLE = "server_sms_download_table";

	/**
	 * 创建员工数据库表
	 */
	public static final String CREATE_SERVER_SMS_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ SERVER_SMS_DOWNLOAD_TABLE
			+ "("
			+ "id  INTEGER PRIMARY KEY AUTOINCREMENT"
			+ ","
			+ SERVER_SMS_ADDRESS
			+ " char(40)"
			+ ","
			+ SERVER_SMS_CODE
			+ " char(20)"
			+ ","
			+ SERVER_SMS_PHONE
			+ " char(15)"
			+ ","
			+ SERVER_SMS_SERVERSITE
			+ " char(40)"
			+ ","
			+ SERVER_SMS_SITE
			+ " char(40)"
			+ ","
			+ SERVER_SMS_SITECODE
			+ " char(20)"
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE + " char(50)" + ")";

	/**
	 * 删除员工数据库表
	 */
	public static final String DROP_SERVER_SMS_TABLE_TABLE = "drop table if exists "
			+ SERVER_SMS_DOWNLOAD_TABLE;
}
